package com.mz.mattress.admin.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.mz.mattress.api.entity.Member;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface MemberMapper extends BaseMapper<Member> {

    @Select("select * from mz_member where mobile=#{mobile} and deleted=0 limit 1")
    Member selectByMobile(@Param("mobile") String mobile);

    Page<Member> listPage(Page page,
                            @Param("mobile") String mobile,
                            @Param("status") Integer status,
                            @Param("startTime") String startTime,
                            @Param("endTime") String endTime);

}
